package com.lmy.dp01.DAO;

import com.lmy.dp01.entity.SC;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface
SCRepository extends JpaRepository<SC, Integer> {


    @Query(nativeQuery = true, value = "SELECT cno FROM tb_sc WHERE sno = #{sno}")
    List<String> findCno(String sno);
}
